package net.tngou.iask.dao;

import java.util.List;
import java.util.Map;

import net.tngou.iask.jdbc.QueryHelper;

/**
 * 
 * @author tngou@tngou.net
 *
 */
public class MemoDao extends BaseDao {

	/**
	 * 
	 * @param patient
	 * @param type
	 * @return
	 */
	public List<Map<String, Object>> getList(long patient,String type) {
		String sql="SELECT memo.*,user.id as uid,user.avatar,user.account,user.name FROM `iask_memo` memo ,`iask_user` user WHERE memo.user=user.id AND memo.oid=? AND otype=? ";
		return QueryHelper.query(sql, patient,type);
	}
}
